//TBWM01AS JOB (0371,TEST,,999),'71P000',CLASS=T,NOTIFY=TBWM01A,
//         MSGCLASS=Q,REGION=1300K
/*ROUTE PRINT LOCAL
//**********************************************************
//SPUFI OUTPUT CLASS=A,COPIES=1,DEST=LOCAL,
//             FORMS=,FCB=,UCS=
//SPUFIGO  EXEC PGM=IKJEFT01,
//     DYNAMNBR=30,
//       REGION=3M
//STEPLIB  DD  DISP=SHR,DSN=DSN1.DB2.TEST.DSNLOAD
//SYSUDUMP DD  SYSOUT=*
//SYSTSPRT DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//SYSABOUT DD  SYSOUT=*
//SYSDBOUT DD  SYSOUT=*
//SYSOUT   DD  SYSOUT=*
//SYSTSIN  DD *
DSN SYSTEM(DB2T)
 RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
     LIB('DSN1.DB2.TEST.DSNLOAD')
/*
//SYSIN    DD *
  DROP TABLESPACE TBWM01A.TBWMT001; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT002; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT003; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT004; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT005; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT006; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT007; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT008; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT009; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT010; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT011; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT012; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT013; COMMIT;
  DROP TABLESPACE TBWM01A.TBWMT014; COMMIT;
--
  CREATE TABLESPACE TBWMT001  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT002  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 80000
             SECQTY  8000
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT003  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT004  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT005  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 25000
             SECQTY  2500
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT006  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 45000
             SECQTY  4500
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT007  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT008  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT009  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT010  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 80000
             SECQTY  8000
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT011  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT012  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT013  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
  CREATE TABLESPACE TBWMT014  IN TBWM01A
       USING STOGROUP VSMTQD2A
             PRIQTY 12000
             SECQTY  1200
             ERASE NO
       FREEPAGE 0
       PCTFREE 0
       BUFFERPOOL BP3
       LOCKSIZE ANY
       CLOSE NO;
COMMIT;
CREATE TABLE TBWM01A.VWIVCPTD
        LIKE TBWM01A.XVWIVCPTD              IN TBWM01A.TBWMT001;
CREATE TABLE TBWM01A.AUTH_SOS
        LIKE TBWM01A.XAUTH_SOS              IN TBWM01A.TBWMT002;
CREATE TABLE TBWM01A.DPAC
        LIKE TBWM01A.XDPAC                  IN TBWM01A.TBWMT003;
CREATE TABLE TBWM01A.DPAC_CONT
        LIKE TBWM01A.XDPAC_CONT             IN TBWM01A.TBWMT004;
CREATE TABLE TBWM01A.DPAC_TO_STIT
        LIKE TBWM01A.XDPAC_TO_STIT          IN TBWM01A.TBWMT005;
CREATE TABLE TBWM01A.IH_ITMG
        LIKE TBWM01A.XIH_ITMG               IN TBWM01A.TBWMT006;
CREATE TABLE TBWM01A.IH_STIT
        LIKE TBWM01A.XIH_STIT               IN TBWM01A.TBWMT007;
CREATE TABLE TBWM01A.VITEMLUCKYSR
        LIKE TBWM01A.XVITEMLUCKYSR          IN TBWM01A.TBWMT008;
CREATE TABLE TBWM01A.VITEMLUCKYNR
        LIKE TBWM01A.XITEMLUCKYNR           IN TBWM01A.TBWMT009;
CREATE TABLE TBWM01A.VVNDRLUCKYSR
        LIKE TBWM01A.XVNDRLUCKYSR           IN TBWM01A.TBWMT010;
CREATE TABLE TBWM01A.ORGU
        LIKE TBWM01A.XORGU                  IN TBWM01A.TBWMT011;
CREATE TABLE TBWM01A.SOS
        LIKE TBWM01A.XSOS                   IN TBWM01A.TBWMT012;
CREATE TABLE TBWM01A.SOS_GRP_EXT_INTF
        LIKE TBWM01A.XSOS_GRP_EXT_INTF      IN TBWM01A.TBWMT013;
CREATE TABLE TBWM01A.STIT_ITMG_IN_STRC
        LIKE TBWM01A.XSTIT_ITMG_IN_STRC     IN TBWM01A.TBWMT014;
//
